/*
 Navicat MySQL Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50721
 Source Host           : localhost
 Source Database       : blog

 Target Server Type    : MySQL
 Target Server Version : 50721
 File Encoding         : utf-8

 Date: 03/21/2021 16:41:06 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `article`
-- ----------------------------
DROP TABLE IF EXISTS `article`;
CREATE TABLE `article` (
  `a_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `a_ctime` datetime DEFAULT NULL,
  `a_title` varchar(255) DEFAULT NULL,
  `a_content` blob,
  `a_sid` int(11) DEFAULT NULL,
  `a_uid` int(11) DEFAULT NULL,
  `a_top` int(11) DEFAULT '0',
  PRIMARY KEY (`a_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `friend`
-- ----------------------------
DROP TABLE IF EXISTS `friend`;
CREATE TABLE `friend` (
  `f_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `f_hostname` varchar(255) DEFAULT NULL,
  `f_address` varchar(255) DEFAULT NULL,
  `f_ctime` datetime DEFAULT NULL,
  PRIMARY KEY (`f_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `setting`
-- ----------------------------
DROP TABLE IF EXISTS `setting`;
CREATE TABLE `setting` (
  `s_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `s_key` varchar(255) DEFAULT NULL,
  `s_val` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`s_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `sort`
-- ----------------------------
DROP TABLE IF EXISTS `sort`;
CREATE TABLE `sort` (
  `s_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `s_name` varchar(255) DEFAULT NULL,
  `s_ctime` datetime DEFAULT NULL,
  PRIMARY KEY (`s_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `sort`
-- ----------------------------
BEGIN;
INSERT INTO `sort` VALUES ('1', null, '2021-02-18 00:00:00');
COMMIT;

-- ----------------------------
--  Table structure for `system_article`
-- ----------------------------
DROP TABLE IF EXISTS `system_article`;
CREATE TABLE `system_article` (
  `a_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `a_ctime` datetime DEFAULT NULL,
  `a_title` varchar(255) DEFAULT NULL,
  `a_content` text,
  `a_type` varchar(255) DEFAULT NULL,
  `a_uid` int(11) DEFAULT NULL,
  PRIMARY KEY (`a_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `users`
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `u_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `u_name` varchar(255) DEFAULT NULL,
  `u_pass` varchar(255) DEFAULT NULL,
  `u_ctime` datetime DEFAULT NULL,
  PRIMARY KEY (`u_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `users`
-- ----------------------------
BEGIN;
INSERT INTO `users` VALUES ('1', 'admin', '123456', '2021-03-19 20:47:27'), ('2', 'admin', '123456', '2021-03-19 20:48:53'), ('3', 'admin', '123456', '2021-03-19 20:49:29'), ('4', 'admin', '123456', '2021-03-19 20:52:43'), ('5', 'admin', '123456', '2021-03-19 20:54:02'), ('6', 'admin', '123456', '2021-03-19 20:54:54'), ('7', 'admin', '123456', '2021-03-19 20:57:25'), ('8', 'admin', '123456', '2021-03-19 21:10:23'), ('9', 'admin', '123456', '2021-03-19 21:14:51'), ('10', 'admin', '123456', '2021-03-19 21:16:42'), ('11', 'admin', '123456', '2021-03-19 21:21:31'), ('12', 'admin', '123456', '2021-03-19 21:22:33'), ('13', 'admin', '123456', '2021-03-21 14:52:54');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
